TG: sql_for_qa/824

SQL для тестировщика

Что произойдет при попытке вставить значение '2025-02-30' в столбец типа DATE без использования функции TO_DATE? (Oracle)

Anonymous Quiz

a) Oracle автоматически преобразует его в 1 марта 2025.

b) Значение будет вставлено как NULL.

c) Будет выброшено исключение ORA-01839: date not valid for month specified.

d) Oracle округлит дату до последнего дня февраля.

e) Данные будут вставлены, но с предупреждением.

f) Значение будет преобразовано в '2025-02-29'.

203 answered

www.tg-me.com/us/SQL для тестировщика/com.sql_for_qa/824

1.0K viewsJun 24 at 04:40

tg-me.com/sql_for_qa/824

Create: 2025-06-24
Last Update: 2025-07-01 03:06:52

BY SQL для тестировщика

Warning: Undefined variable $i in /var/www/tg-me/post.php on line 283

Share with your friend now:
tg-me.com/sql_for_qa/824

SQL для тестировщика Telegram | DID YOU KNOW?

The Singapore stock market has alternated between positive and negative finishes through the last five trading days since the end of the two-day winning streak in which it had added more than a dozen points or 0.4 percent. The Straits Times Index now sits just above the 3,060-point plateau and it's likely to see a narrow trading range on Monday.

The global forecast for the Asian markets is murky following recent volatility, with crude oil prices providing support in what has been an otherwise tough month. The European markets were down and the U.S. bourses were mixed and flat and the Asian markets figure to split the difference.The TSE finished modestly lower on Friday following losses from the financial shares and property stocks.For the day, the index sank 15.09 points or 0.49 percent to finish at 3,061.35 after trading between 3,057.84 and 3,089.78. Volume was 1.39 billion shares worth 1.30 billion Singapore dollars. There were 285 decliners and 184 gainers.